Power Programmierung/Power-Programmierung (Tewi)(1994).iso/magazine/dbms_mag/9103/sql2.mar

Text File | 1991-01-22 | 314b | 2 lines

CREATE VIEW complete_order(c#,name,i#,date,order_value) AS  SELECT customer.c#,customer.name,invoice.i#,invoice.date         SUM(part.price*litem.qty)    FROM part, litem, invoice, customer   WHERE part.p# = litem.p#      AND litem.i# = invoice.i#     AND invoice.c# = customer.c#   GROUP BY 1, 2, 3, 4;